package db;

import java.sql.SQLException;
import java.util.ArrayList;

import model.City;

public interface IFCity {
	
	public ArrayList<City> getCitiesByAllInfo(String search) throws SQLException;
	
	public ArrayList<City> getAllCities() throws SQLException;
	
	public ArrayList<City> getCitiesByCountryName(String name) throws SQLException;
	
	public ArrayList<City>  getCityByName(String name) throws SQLException;
	
	public City getOneCity(String column, String value, String countryName) throws SQLException;
	
	public int createCity(City city) throws Exception;
	
	public int updateCity(City city) throws Exception;
	

}
